Check Table

Check Table checks a table or tables for errors. Currently, MySQL supports checking only for MyISAM, InnoDB and ARCHIVE tables. For MyISAM tables, the key statistics are updated as well.

Hint: Just simply control-click the table and select Maintain Table -> Check Table.

The other check options that can be given are shown in the following table:

Type
Meaning
QUICK Don't scan the rows to check for wrong links.
FAST Don't scan the rows to check for wrong links.
CHANGED Only check tables which have been changed since last check or haven't been closed properly.
EXTENDED Do a full key lookup for all keys for each row. This ensures that the table is 100 % consistent, but will take a long time!

Related topics:
Analyze Table
Optimize Table
Repair Table